﻿/*

CREATE ALGORITHM = UNDEFINED VIEW `v_article_tags` AS select a.id article_id, t.id tag_id , t.name tagname from articles a left join article_tags at on a.id = at.article_id left join tags t on at.tag_id = t.id;

CREATE TABLE `article_attachments` (
	`Id` BIGINT NOT NULL AUTO_INCREMENT,
	`article_id` BIGINT NOT NULL,
	`path` VARCHAR(2048) NOT NULL,
	`filename` VARCHAR(2048) NOT NULL,
	`extension` VARCHAR(10) NOT NULL,
	`downloads` INT NOT NULL DEFAULT '0',
	`hash` VARCHAR(255) NULL,
	`hash_time` DATETIME NULL,
	PRIMARY KEY (`Id`)
)
COLLATE='utf8_general_ci'
ENGINE=MyISAM;



*/